dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleCommand Class / ExecuteArray Method / ExecuteArray(Int32,Int64[]) Method
Number of times to execute SQL statement.
Returns the numbers of rows affected for each array element.

ExecuteArray(Int32,Int64[]) Method
Executes SQL statement specified number of times. Returns the numbers of rows affected for each array element in its out parameter. Supported only for Oracle 12c Release 1 (12.1) - both server and client.
Syntax
'Declaration
 
Public Overloads Function ExecuteArray( _
   ByVal iters As Integer, _
   ByRef rowsAffected() As Long _
) As Integer
 

Parameters

iters
Number of times to execute SQL statement.
rowsAffected
Returns the numbers of rows affected for each array element.

Return Value

The return value is the number of rows affected by the statement.
Remarks
The ExecuteArray method allows to execute several SQL statements for the one time. The main advantage of using this method is that only one round trip to the server is used to execute several queries, which speeds up queries execution compared to consecutive invocation.

All parameters of the query must have System.Array type and an elements of the array must have type corresponding to the type of the parameter. The value of the iters parameter must be equal to the number of elements of the array.

Refer to "Working with Array Binding" article for detailed information and example.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also